<template>
<upload-excel :on-success="success"></upload-excel>
</template>

<script>
import  {importEmployee} from "@/api/employees";

export default {
methods:{

 async success({header,results}){
    const userRelations = {
      '入职日期': 'timeOfEntry',
      '手机号': 'mobile',
      '姓名': 'username',
      '转正日期': 'correctionTime',
      '工号': 'workNumber'
    }
    var arr=[]
    results.forEach(item=>{

      var userInfo={}
      Object.keys(item).forEach(key =>{
//由于后端接口只能接收英文
        if (userRelations[key] === 'timeOfEntry' || userRelations[key] === 'correctionTime') {
          userInfo[userRelations[key]] = new Date(this.formatDate(item[key], '/')) // 只有这样, 才能入库
          return
        }
          userInfo[userRelations[key]]=item[key]




      })

      arr.push(userInfo)
    })
    await importEmployee(arr) // 调用导入接口
   this.$message.success('导入成功')
    this.$router.back()

  },
  //转化excel的日期格式
  formatDate(numb, format) {
    const time = new Date((numb - 1) * 24 * 3600000 + 1)
    time.setYear(time.getFullYear() - 70)
    const year = time.getFullYear() + ''
    const month = time.getMonth() + 1 + ''
    const date = time.getDate() - 1 + ''
    if (format && format.length === 1) {
      return year + format + month + format + date
    }
    return year + (month < 10 ? '0' + month : month) + (date < 10 ? '0' + date : date)
  }

}

}
</script>

<style scoped>

</style>
